create external table jms_ods.tab_mainline_vehicleloading
(
  id              bigint      comment 'id',
  distributecode  string      comment '转运中心编码',
  distributename  string      comment '转运中心',
  vehicletype     string      comment '车型',
  vehiclevolume   string      comment '核载体积m3',
  vehicleweight   string      comment '核载重量(单位：吨)',
  vehiclecount    string      comment '核载票数',
  operator        string      comment '操作人',
  operatortime    timestamp   comment '操作时间',
  averagevolume   string      comment '每票平均体积m3',
  agentcode       string      comment '代理区编码',
  agentname       string      comment '代理区名称'
)
comment '干线核载维护表'
partitioned by (dt string comment '时间分区')
stored as parquet
location '/dw/hive/jms_ods.db/external/tab_mainline_vehicleloading'
tblproperties (
'parquet.column.index.access' = 'true'
);